package org.nado.menu;

import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;

public interface MenuDAO {

	@Insert("insert into tbl_menu (menu_id, menu_name) values ( #{menu_id}, #{menu_name} )")
	public abstract void creat(MenuVO vo) throws Exception;
	
	@Select("select menu_id, menu_name from tbl_menu where menu_id = #{menu_id}")
	public abstract MenuVO read(String menu_id) throws Exception;
	
	@Update("update tbl_menu set menu_name = #{menu_name} where menu_id = #{menu_id}")
	public abstract void update(MenuVO vo) throws Exception;
	
	@Delete("delete from tbl_menu where menu_id = #{menu_id}")
	public abstract void delete(String menu_id) throws Exception;
	
}
